﻿CREATE TABLE [dbo].[DM_TaiSan] (
    [ma_tscd]    VARCHAR (50)   NOT NULL,
    [ten_tscd]   NVARCHAR (255) NULL,
    [so_phxuat]  NVARCHAR (255) NULL,
    [so_ctu]     NVARCHAR (255) NULL,
    [so_ctutam]  NVARCHAR (255) NULL,
    [ngay_ctu]   DATETIME       NULL,
    [madv]       NVARCHAR (255) NULL,
    [madvcu]     NVARCHAR (255) NULL,
    [madvmoi]    NVARCHAR (255) NULL,
    [ten_dv]     NVARCHAR (255) NULL,
    [sotk]       NVARCHAR (255) NULL,
    [ma_loai]    NVARCHAR (255) NULL,
    [ten_loaits] NVARCHAR (255) NULL,
    [ma_ptnx]    NVARCHAR (255) NULL,
    [muon]       BIT            NOT NULL,
    [so_cttra]   NVARCHAR (255) NULL,
    [ngay_tra]   NVARCHAR (255) NULL,
    [tk_co]      NVARCHAR (255) NULL,
    [ma_co]      NVARCHAR (255) NULL,
    [ma_kh]      NVARCHAR (255) NULL,
    [dv_ban]     NVARCHAR (255) NULL,
    [ma_sd]      NVARCHAR (255) NULL,
    [tk_kh]      NVARCHAR (255) NULL,
    [ng_chuyen]  NVARCHAR (255) NULL,
    [maphieu]    NVARCHAR (255) NULL,
    [ct_cp]      NVARCHAR (255) NULL,
    [loaitien]   NVARCHAR (255) NULL,
    [ty_gia]     FLOAT (53)     NULL,
    [quy_cach]   NVARCHAR (255) NULL,
    [dvt]        NVARCHAR (255) NULL,
    [ng_gia_tc]  FLOAT (53)     NULL,
    [ng_gia_nt]  FLOAT (53)     NULL,
    [ng_gia_gs]  FLOAT (53)     NULL,
    [ng_thuc_gs] FLOAT (53)     NULL,
    [ng_thuc_nt] FLOAT (53)     NULL,
    [tg_cl_gs]   FLOAT (53)     NULL,
    [tg_kh_gs]   FLOAT (53)     NULL,
    [thg_kh]     NVARCHAR (255) NULL,
    [thg_khts]   NVARCHAR (255) NULL,
    [tl_kh]      FLOAT (53)     NULL,
    [maht]       NVARCHAR (255) NULL,
    [dien_giai]  NVARCHAR (255) NULL,
    [ngay_sd]    DATETIME       NULL,
    [ngay_tl]    NVARCHAR (255) NULL,
    [lydo_tl]    NVARCHAR (255) NULL,
    [so_cttl]    NVARCHAR (255) NULL,
    [so_luong]   FLOAT (53)     NULL,
    [sh_tscd]    NVARCHAR (255) NULL,
    [nuoc_sx]    NVARCHAR (255) NULL,
    [cs_tke]     NVARCHAR (255) NULL,
    [dieuchinh]  BIT            NOT NULL,
    [dungchung]  BIT            NOT NULL,
    [kt_kh]      BIT            NOT NULL,
    [xoa]        BIT            NOT NULL,
    [ngay_xoa]   NVARCHAR (255) NULL,
    [sd_dakh]    FLOAT (53)     NULL,
    [sd_tang]    FLOAT (53)     NULL,
    [sd_giam]    FLOAT (53)     NULL,
    [ngay_gnk]   NVARCHAR (255) NULL,
    [sddk]       BIT            NOT NULL,
    [so_khung]   NVARCHAR (255) NULL,
    [so_may]     NVARCHAR (255) NULL,
    [ch_ts]      BIT            NOT NULL,
    [so_hdon]    NVARCHAR (255) NULL,
    [ngay_hd]    NVARCHAR (255) NULL,
    [dv_nhan]    NVARCHAR (255) NULL,
    [tk_vat]     NVARCHAR (255) NULL,
    [tkco_vat]   NVARCHAR (255) NULL,
    [maco_vat]   NVARCHAR (255) NULL,
    [tk_kcnv]    NVARCHAR (255) NULL,
    [tkco_kcnv]  NVARCHAR (255) NULL,
    [tien_vat]   FLOAT (53)     NULL,
    [tien_kcnv]  FLOAT (53)     NULL,
    [vat_thuc]   FLOAT (53)     NULL,
    [kcnv_thuc]  FLOAT (53)     NULL,
    [ten_dvnh]   NVARCHAR (255) NULL,
    [lydo_nhan]  NVARCHAR (255) NULL,
    [dgia_ban]   FLOAT (53)     NULL,
    [vat_tg]     FLOAT (53)     NULL,
    [vat_gi]     FLOAT (53)     NULL,
    [kcnv_tg]    FLOAT (53)     NULL,
    [kcnv_gi]    FLOAT (53)     NULL,
    [tgia_vnd]   FLOAT (53)     NULL,
    [tgia_usd]   FLOAT (53)     NULL,
    [thsuat_vat] FLOAT (53)     NULL,
    [ktra_nk]    BIT            NOT NULL,
    [thsuat_nk]  FLOAT (53)     NULL,
    [tk_thue]    NVARCHAR (255) NULL,
    [tygia_nk]   FLOAT (53)     NULL,
    [tgvnd_nk]   FLOAT (53)     NULL,
    [ngay_ch]    DATETIME       NULL,
    CONSTRAINT [PK_DM_TaiSan] PRIMARY KEY CLUSTERED ([ma_tscd] ASC)
);

